package com.ruoyi.stuactivity.mapper;

import com.ruoyi.stuactivity.domain.StudentActivityInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface StudentActivityInfoMapper {
    /**
     * 根据学生ID查询创新创业活动
     */
    List<StudentActivityInfo> selectInnovationActivitiesByStudentId(@Param("studentId") String studentId);

    /**
     * 根据学生ID查询文体活动
     */
    List<StudentActivityInfo> selectwentiActivitiesByStudentId(@Param("studentId") String studentId);

    /**
     * 根据学生ID查询技能特长活动
     */
    List<StudentActivityInfo> selectjntcActivityByStudentId(@Param("studentId") String studentId);

    /**
     * 根据学生ID查询社会实践活动
     */
    int selectshijianActivityByStudentId(@Param("studentId") String studentId);

    /**
     * 根据学生ID查询思想成长活动
     */
    List<StudentActivityInfo> selectsixiangActivityByStudentId(@Param("studentId") String studentId);

    double selectzhishiByStudentId(@Param("studentId")String studentId);
}
